package com.szt.ynb.server.router.repository;

import java.util.List;

import org.springframework.data.domain.Sort;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;

import com.szt.ynb.server.router.entity.Server;

public interface ServerRepositroy extends JpaRepository<Server, Long> {
	
	@Query
	List<Server> findByserverNameAndVersionAndStatus(String serverName, String version, Integer status, Sort sort);
	
	@Query
	Server findByServerNameAndVersionAndUrl(String serverName, String version, String url);
	
}